Delete row
Purpose of this building block
With this building block you can remove rows from an existing worksheet.
2 variables
0 variables
${fileId}
${rowNumber}
Possible use cases
- Remove subscribers from a subscription list
- Delete all rows from a sheet
Configuration
Click on the bold text in the title of the building block to open the configuration dialog.
Edit
Click on the edit icon to edit the selected Google Sheet in a new browser tab or window.
Reload
Click on the reload icon to scan the sheet again to track down added or removed worksheets or columns.
When dragging this block into the flow you can either select an existing spreadsheet from Google Drive or you can create a new one. If you choose to select an existing sheet, a file picker dialog will help you to find the sheet on your Google Drive. Creating a new spreadsheet will open the new sheet in a new browser tab.
After selecting the Google Sheet a dialog will allows you to specify the row to be deleted.
As you are deleting an existing row you will have to specify the row number to be deleted. This can either be done by providing a fixed number or a variable containing the row number to be removed.
You can even update multiple rows at once. If you for example use the Load worksheet building block you will find the loaded row numbers in a variable called $[worksheetname.rowNumber]. The square brackets indicate that this variable contains multiple values. Use this variable will remove all loaded rows.
Useful combinations
Clear worksheet before adding rows
Before adding rows to a sheet you may want to consider clearing existing entries. As in the contact of file list examples in the Create row building you do not want the same files and contacts to be added each time you execute your Ultradox flow.
To have your list only containing current information clear old entries by first loading the sheet and for each row execute the Delete row building block. This sequence of building blocks should be added as the first steps of you flow before creating new rows.
In the settings of the Delete row building block you need to set the row to "2". As row one refers to the header row - which is ignored using the normal settings - the first row containing your content is row two.
Copy the Delete All Rows app to see this building block in action
Questions and Feedback
If you have any comments on this guide, feel free to add them right to the Google document that we are using to create this site.
If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.
Last Updated:
